Dataset statistics
| Number of variables | 15 |
|---|---|
| Number of observations | 112650 |
| Missing cells | 6484 |
| Missing cells (%) | 0.4% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 13.8 MiB |
| Average record size in memory | 128.0 B |
Variable types
| Categorical | 5 |
|---|---|
| Numeric | 10 |
product_id has a high cardinality: 32951 distinct values | High cardinality |
product_category_name has a high cardinality: 73 distinct values | High cardinality |
order_id has a high cardinality: 98666 distinct values | High cardinality |
seller_id has a high cardinality: 3095 distinct values | High cardinality |
shipping_limit_date has a high cardinality: 93318 distinct values | High cardinality |
product_weight_g is highly overall correlated with product_length_cm and 3 other fields | High correlation |
product_length_cm is highly overall correlated with product_weight_g and 1 other fields | High correlation |
product_height_cm is highly overall correlated with product_weight_g | High correlation |
product_width_cm is highly overall correlated with product_weight_g and 1 other fields | High correlation |
price is highly overall correlated with product_weight_g | High correlation |
product_category_name has 1603 (1.4%) missing values | Missing |
product_name_lenght has 1603 (1.4%) missing values | Missing |
product_description_lenght has 1603 (1.4%) missing values | Missing |
product_photos_qty has 1603 (1.4%) missing values | Missing |
order_id is uniformly distributed | Uniform |
shipping_limit_date is uniformly distributed | Uniform |
Reproduction
| Analysis started | 2023-06-23 13:25:24.786977 |
|---|---|
| Analysis finished | 2023-06-23 13:25:48.503480 |
| Duration | 23.72 seconds |
| Software version | ydata-profiling vv4.1.2 |
| Download configuration | config.json |
product_id
Categorical
| Distinct | 32951 |
|---|---|
| Distinct (%) | 29.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.7 MiB |
| aca2eb7d00ea1a7b8ebd4e68314663af | 527 |
|---|---|
| 99a4788cb24856965c36a24e339b6058 | 488 |
| 422879e10f46682990de24d770e7f83d | 484 |
| 389d119b48cf3043d311335e499d9c6b | 392 |
| 368c6c730842d78016ad823897a372db | 388 |
| Other values (32946) |
Length
| Max length | 32 |
|---|---|
| Median length | 32 |
| Mean length | 32 |
| Min length | 32 |
Characters and Unicode
| Total characters | 3604800 |
|---|---|
| Distinct characters | 16 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 18117 ? |
|---|---|
| Unique (%) | 16.1% |
Sample
| 1st row | 1e9e8ef04dbcff4541ed26657ea517e5 |
|---|---|
| 2nd row | 3aa071139cb16b67ca9e5dea641aaa2f |
| 3rd row | 96bd76ec8810374ed1b65e291975717f |
| 4th row | cef67bcfe19066a932b7673e239eb23d |
| 5th row | 9dc1a7de274444849c219cff195d0b71 |
Common Values
| Value | Count | Frequency (%) |
| aca2eb7d00ea1a7b8ebd4e68314663af | 527 | 0.5% |
| 99a4788cb24856965c36a24e339b6058 | 488 | 0.4% |
| 422879e10f46682990de24d770e7f83d | 484 | 0.4% |
| 389d119b48cf3043d311335e499d9c6b | 392 | 0.3% |
| 368c6c730842d78016ad823897a372db | 388 | 0.3% |
| 53759a2ecddad2bb87a079a1f1519f73 | 373 | 0.3% |
| d1c427060a0f73f6b889a5c7c61f2ac4 | 343 | 0.3% |
| 53b36df67ebb7c41585e8d54d6772e08 | 323 | 0.3% |
| 154e7e31ebfa092203795c972e5804a6 | 281 | 0.2% |
| 3dd2a17168ec895c781a9191c1e95ad7 | 274 | 0.2% |
| Other values (32941) | 108777 |
Length
| Value | Count | Frequency (%) |
| aca2eb7d00ea1a7b8ebd4e68314663af | 527 | 0.5% |
| 99a4788cb24856965c36a24e339b6058 | 488 | 0.4% |
| 422879e10f46682990de24d770e7f83d | 484 | 0.4% |
| 389d119b48cf3043d311335e499d9c6b | 392 | 0.3% |
| 368c6c730842d78016ad823897a372db | 388 | 0.3% |
| 53759a2ecddad2bb87a079a1f1519f73 | 373 | 0.3% |
| d1c427060a0f73f6b889a5c7c61f2ac4 | 343 | 0.3% |
| 53b36df67ebb7c41585e8d54d6772e08 | 323 | 0.3% |
| 154e7e31ebfa092203795c972e5804a6 | 281 | 0.2% |
| 3dd2a17168ec895c781a9191c1e95ad7 | 274 | 0.2% |
| Other values (32941) | 108777 |
Most occurring characters
| Value | Count | Frequency (%) |
| 3 | 231812 | 6.4% |
| 9 | 229514 | 6.4% |
| e | 227504 | 6.3% |
| 7 | 227012 | 6.3% |
| 8 | 226818 | 6.3% |
| 4 | 226338 | 6.3% |
| a | 225916 | 6.3% |
| c | 225040 | 6.2% |
| 0 | 224967 | 6.2% |
| 2 | 224937 | 6.2% |
| Other values (6) | 1334942 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 2262781 | |
| Lowercase Letter | 1342019 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 3 | 231812 | |
| 9 | 229514 | |
| 7 | 227012 | |
| 8 | 226818 | |
| 4 | 226338 | |
| 0 | 224967 | |
| 2 | 224937 | |
| 5 | 224337 | |
| 6 | 224102 | |
| 1 | 222944 |
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 227504 | |
| a | 225916 | |
| c | 225040 | |
| b | 223674 | |
| d | 221547 | |
| f | 218338 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 2262781 | |
| Latin | 1342019 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 3 | 231812 | |
| 9 | 229514 | |
| 7 | 227012 | |
| 8 | 226818 | |
| 4 | 226338 | |
| 0 | 224967 | |
| 2 | 224937 | |
| 5 | 224337 | |
| 6 | 224102 | |
| 1 | 222944 |
Latin
| Value | Count | Frequency (%) |
| e | 227504 | |
| a | 225916 | |
| c | 225040 | |
| b | 223674 | |
| d | 221547 | |
| f | 218338 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 3604800 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 3 | 231812 | 6.4% |
| 9 | 229514 | 6.4% |
| e | 227504 | 6.3% |
| 7 | 227012 | 6.3% |
| 8 | 226818 | 6.3% |
| 4 | 226338 | 6.3% |
| a | 225916 | 6.3% |
| c | 225040 | 6.2% |
| 0 | 224967 | 6.2% |
| 2 | 224937 | 6.2% |
| Other values (6) | 1334942 |
product_category_name
Categorical
HIGH CARDINALITY  MISSING 
| Distinct | 73 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 1603 |
| Missing (%) | 1.4% |
| Memory size | 1.7 MiB |
| cama_mesa_banho | |
|---|---|
| beleza_saude | |
| esporte_lazer | |
| moveis_decoracao | |
| informatica_acessorios | |
| Other values (68) |
Length
| Max length | 46 |
|---|---|
| Median length | 32 |
| Mean length | 14.861113 |
| Min length | 3 |
Characters and Unicode
| Total characters | 1650282 |
|---|---|
| Distinct characters | 28 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | perfumaria |
|---|---|
| 2nd row | artes |
| 3rd row | esporte_lazer |
| 4th row | bebes |
| 5th row | utilidades_domesticas |
Common Values
| Value | Count | Frequency (%) |
| cama_mesa_banho | 11115 | 9.9% |
| beleza_saude | 9670 | 8.6% |
| esporte_lazer | 8641 | 7.7% |
| moveis_decoracao | 8334 | 7.4% |
| informatica_acessorios | 7827 | 6.9% |
| utilidades_domesticas | 6964 | 6.2% |
| relogios_presentes | 5991 | 5.3% |
| telefonia | 4545 | 4.0% |
| ferramentas_jardim | 4347 | 3.9% |
| automotivo | 4235 | 3.8% |
| Other values (63) | 39378 |
Length
| Value | Count | Frequency (%) |
| cama_mesa_banho | 11115 | 10.0% |
| beleza_saude | 9670 | 8.7% |
| esporte_lazer | 8641 | 7.8% |
| moveis_decoracao | 8334 | 7.5% |
| informatica_acessorios | 7827 | 7.0% |
| utilidades_domesticas | 6964 | 6.3% |
| relogios_presentes | 5991 | 5.4% |
| telefonia | 4545 | 4.1% |
| ferramentas_jardim | 4347 | 3.9% |
| automotivo | 4235 | 3.8% |
| Other values (63) | 39378 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 201012 | |
| a | 197895 | |
| s | 164475 | |
| o | 163286 | |
| i | 109732 | 6.6% |
| r | 106492 | 6.5% |
| _ | 104608 | 6.3% |
| t | 79595 | 4.8% |
| c | 78128 | 4.7% |
| m | 74189 | 4.5% |
| Other values (18) | 370870 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1545406 | |
| Connector Punctuation | 104608 | 6.3% |
| Decimal Number | 268 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 201012 | |
| a | 197895 | |
| s | 164475 | |
| o | 163286 | |
| i | 109732 | 7.1% |
| r | 106492 | 6.9% |
| t | 79595 | 5.2% |
| c | 78128 | 5.1% |
| m | 74189 | 4.8% |
| n | 56353 | 3.6% |
| Other values (16) | 314249 |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 104608 |
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 268 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1545406 | |
| Common | 104876 | 6.4% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 201012 | |
| a | 197895 | |
| s | 164475 | |
| o | 163286 | |
| i | 109732 | 7.1% |
| r | 106492 | 6.9% |
| t | 79595 | 5.2% |
| c | 78128 | 5.1% |
| m | 74189 | 4.8% |
| n | 56353 | 3.6% |
| Other values (16) | 314249 |
Common
| Value | Count | Frequency (%) |
| _ | 104608 | |
| 2 | 268 | 0.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1650282 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 201012 | |
| a | 197895 | |
| s | 164475 | |
| o | 163286 | |
| i | 109732 | 6.6% |
| r | 106492 | 6.5% |
| _ | 104608 | 6.3% |
| t | 79595 | 4.8% |
| c | 78128 | 4.7% |
| m | 74189 | 4.5% |
| Other values (18) | 370870 |
product_name_lenght
Real number (ℝ)
| Distinct | 66 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 1603 |
| Missing (%) | 1.4% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 48.775978 |
| Minimum | 5 |
|---|---|
| Maximum | 76 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.7 MiB |
Quantile statistics
| Minimum | 5 |
|---|---|
| 5-th percentile | 29 |
| Q1 | 42 |
| median | 52 |
| Q3 | 57 |
| 95-th percentile | 60 |
| Maximum | 76 |
| Range | 71 |
| Interquartile range (IQR) | 15 |
Descriptive statistics
| Standard deviation | 10.025581 |
|---|---|
| Coefficient of variation (CV) | 0.20554341 |
| Kurtosis | 0.15660995 |
| Mean | 48.775978 |
| Median Absolute Deviation (MAD) | 6 |
| Skewness | -0.90714361 |
| Sum | 5416426 |
| Variance | 100.51227 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 59 | 8322 | 7.4% |
| 60 | 7713 | 6.8% |
| 56 | 6504 | 5.8% |
| 58 | 6435 | 5.7% |
| 57 | 5993 | 5.3% |
| 55 | 5541 | 4.9% |
| 54 | 5265 | 4.7% |
| 53 | 4179 | 3.7% |
| 52 | 4158 | 3.7% |
| 49 | 3556 | 3.2% |
| Other values (56) | 53381 |
| Value | Count | Frequency (%) |
| 5 | 9 | < 0.1% |
| 6 | 3 | < 0.1% |
| 7 | 2 | < 0.1% |
| 8 | 4 | < 0.1% |
| 9 | 14 | < 0.1% |
| 10 | 5 | < 0.1% |
| 11 | 10 | < 0.1% |
| 12 | 38 | |
| 13 | 26 | |
| 14 | 45 |
| Value | Count | Frequency (%) |
| 76 | 1 | < 0.1% |
| 72 | 9 | < 0.1% |
| 69 | 1 | < 0.1% |
| 68 | 1 | < 0.1% |
| 67 | 2 | < 0.1% |
| 66 | 1 | < 0.1% |
| 64 | 164 | 0.1% |
| 63 | 1261 | |
| 62 | 156 | 0.1% |
| 61 | 235 | 0.2% |
product_description_lenght
Real number (ℝ)
| Distinct | 2960 |
|---|---|
| Distinct (%) | 2.7% |
| Missing | 1603 |
| Missing (%) | 1.4% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 787.86703 |
| Minimum | 4 |
|---|---|
| Maximum | 3992 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.7 MiB |
Quantile statistics
| Minimum | 4 |
|---|---|
| 5-th percentile | 161 |
| Q1 | 348 |
| median | 603 |
| Q3 | 987 |
| 95-th percentile | 2124 |
| Maximum | 3992 |
| Range | 3988 |
| Interquartile range (IQR) | 639 |
Descriptive statistics
| Standard deviation | 652.13561 |
|---|---|
| Coefficient of variation (CV) | 0.82772293 |
| Kurtosis | 4.9012551 |
| Mean | 787.86703 |
| Median Absolute Deviation (MAD) | 294 |
| Skewness | 2.0055505 |
| Sum | 87490270 |
| Variance | 425280.85 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 341 | 690 | 0.6% |
| 1893 | 636 | 0.6% |
| 348 | 620 | 0.6% |
| 903 | 583 | 0.5% |
| 492 | 564 | 0.5% |
| 245 | 547 | 0.5% |
| 366 | 523 | 0.5% |
| 236 | 489 | 0.4% |
| 340 | 465 | 0.4% |
| 919 | 426 | 0.4% |
| Other values (2950) | 105504 | |
| (Missing) | 1603 | 1.4% |
| Value | Count | Frequency (%) |
| 4 | 6 | |
| 8 | 2 | < 0.1% |
| 15 | 1 | < 0.1% |
| 20 | 6 | |
| 23 | 1 | < 0.1% |
| 26 | 2 | < 0.1% |
| 27 | 3 | < 0.1% |
| 28 | 2 | < 0.1% |
| 30 | 8 | |
| 31 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 3992 | 2 | < 0.1% |
| 3988 | 1 | < 0.1% |
| 3985 | 3 | |
| 3976 | 5 | |
| 3963 | 1 | < 0.1% |
| 3956 | 3 | |
| 3954 | 2 | < 0.1% |
| 3950 | 2 | < 0.1% |
| 3949 | 1 | < 0.1% |
| 3948 | 1 | < 0.1% |
product_photos_qty
Real number (ℝ)
| Distinct | 19 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 1603 |
| Missing (%) | 1.4% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.209713 |
| Minimum | 1 |
|---|---|
| Maximum | 20 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.7 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 3 |
| 95-th percentile | 6 |
| Maximum | 20 |
| Range | 19 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 1.7214385 |
|---|---|
| Coefficient of variation (CV) | 0.77903259 |
| Kurtosis | 4.8347748 |
| Mean | 2.209713 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 1.9079075 |
| Sum | 245382 |
| Variance | 2.9633504 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 56028 | |
| 2 | 21963 | 19.5% |
| 3 | 12392 | 11.0% |
| 4 | 8437 | 7.5% |
| 5 | 5368 | 4.8% |
| 6 | 3786 | 3.4% |
| 7 | 1501 | 1.3% |
| 8 | 727 | 0.6% |
| 10 | 342 | 0.3% |
| 9 | 313 | 0.3% |
| Other values (9) | 190 | 0.2% |
| (Missing) | 1603 | 1.4% |
| Value | Count | Frequency (%) |
| 1 | 56028 | |
| 2 | 21963 | 19.5% |
| 3 | 12392 | 11.0% |
| 4 | 8437 | 7.5% |
| 5 | 5368 | 4.8% |
| 6 | 3786 | 3.4% |
| 7 | 1501 | 1.3% |
| 8 | 727 | 0.6% |
| 9 | 313 | 0.3% |
| 10 | 342 | 0.3% |
| Value | Count | Frequency (%) |
| 20 | 1 | < 0.1% |
| 19 | 2 | < 0.1% |
| 18 | 4 | < 0.1% |
| 17 | 11 | < 0.1% |
| 15 | 12 | < 0.1% |
| 14 | 6 | < 0.1% |
| 13 | 30 | < 0.1% |
| 12 | 53 | < 0.1% |
| 11 | 71 | 0.1% |
| 10 | 342 |
product_weight_g
Real number (ℝ)
| Distinct | 2204 |
|---|---|
| Distinct (%) | 2.0% |
| Missing | 18 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2093.672 |
| Minimum | 0 |
|---|---|
| Maximum | 40425 |
| Zeros | 8 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.7 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 125 |
| Q1 | 300 |
| median | 700 |
| Q3 | 1800 |
| 95-th percentile | 9750 |
| Maximum | 40425 |
| Range | 40425 |
| Interquartile range (IQR) | 1500 |
Descriptive statistics
| Standard deviation | 3751.5969 |
|---|---|
| Coefficient of variation (CV) | 1.7918742 |
| Kurtosis | 16.264762 |
| Mean | 2093.672 |
| Median Absolute Deviation (MAD) | 500 |
| Skewness | 3.598715 |
| Sum | 2.3581447 Ă— 108 |
| Variance | 14074479 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 200 | 6778 | 6.0% |
| 150 | 5276 | 4.7% |
| 250 | 4520 | 4.0% |
| 300 | 4258 | 3.8% |
| 400 | 3613 | 3.2% |
| 100 | 3490 | 3.1% |
| 350 | 3161 | 2.8% |
| 500 | 2696 | 2.4% |
| 600 | 2695 | 2.4% |
| 700 | 2050 | 1.8% |
| Other values (2194) | 74095 |
| Value | Count | Frequency (%) |
| 0 | 8 | < 0.1% |
| 2 | 5 | < 0.1% |
| 25 | 3 | < 0.1% |
| 50 | 949 | |
| 53 | 2 | < 0.1% |
| 54 | 1 | < 0.1% |
| 55 | 2 | < 0.1% |
| 58 | 1 | < 0.1% |
| 60 | 9 | < 0.1% |
| 61 | 5 | < 0.1% |
| Value | Count | Frequency (%) |
| 40425 | 3 | < 0.1% |
| 30000 | 282 | |
| 29800 | 1 | < 0.1% |
| 29750 | 1 | < 0.1% |
| 29700 | 4 | < 0.1% |
| 29600 | 5 | < 0.1% |
| 29500 | 2 | < 0.1% |
| 29250 | 1 | < 0.1% |
| 29150 | 1 | < 0.1% |
| 29100 | 1 | < 0.1% |
product_length_cm
Real number (ℝ)
| Distinct | 99 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 18 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 30.153669 |
| Minimum | 7 |
|---|---|
| Maximum | 105 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.7 MiB |
Quantile statistics
| Minimum | 7 |
|---|---|
| 5-th percentile | 16 |
| Q1 | 18 |
| median | 25 |
| Q3 | 38 |
| 95-th percentile | 62 |
| Maximum | 105 |
| Range | 98 |
| Interquartile range (IQR) | 20 |
Descriptive statistics
| Standard deviation | 16.153449 |
|---|---|
| Coefficient of variation (CV) | 0.53570427 |
| Kurtosis | 3.7454877 |
| Mean | 30.153669 |
| Median Absolute Deviation (MAD) | 8 |
| Skewness | 1.761463 |
| Sum | 3396268 |
| Variance | 260.93392 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 16 | 17603 | 15.6% |
| 20 | 10529 | 9.3% |
| 30 | 7558 | 6.7% |
| 17 | 5963 | 5.3% |
| 18 | 5727 | 5.1% |
| 25 | 4676 | 4.2% |
| 19 | 4661 | 4.1% |
| 40 | 4090 | 3.6% |
| 22 | 3827 | 3.4% |
| 50 | 2967 | 2.6% |
| Other values (89) | 45031 |
| Value | Count | Frequency (%) |
| 7 | 32 | < 0.1% |
| 8 | 2 | < 0.1% |
| 9 | 4 | < 0.1% |
| 10 | 8 | < 0.1% |
| 11 | 95 | 0.1% |
| 12 | 40 | < 0.1% |
| 13 | 60 | 0.1% |
| 14 | 135 | 0.1% |
| 15 | 202 | 0.2% |
| 16 | 17603 |
| Value | Count | Frequency (%) |
| 105 | 328 | |
| 104 | 33 | < 0.1% |
| 103 | 46 | < 0.1% |
| 102 | 58 | 0.1% |
| 101 | 107 | 0.1% |
| 100 | 381 | |
| 99 | 35 | < 0.1% |
| 98 | 47 | < 0.1% |
| 97 | 11 | < 0.1% |
| 96 | 8 | < 0.1% |
product_height_cm
Real number (ℝ)
| Distinct | 102 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 18 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 16.593766 |
| Minimum | 2 |
|---|---|
| Maximum | 105 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.7 MiB |
Quantile statistics
| Minimum | 2 |
|---|---|
| 5-th percentile | 3 |
| Q1 | 8 |
| median | 13 |
| Q3 | 20 |
| 95-th percentile | 45 |
| Maximum | 105 |
| Range | 103 |
| Interquartile range (IQR) | 12 |
Descriptive statistics
| Standard deviation | 13.443483 |
|---|---|
| Coefficient of variation (CV) | 0.81015265 |
| Kurtosis | 7.3846878 |
| Mean | 16.593766 |
| Median Absolute Deviation (MAD) | 6 |
| Skewness | 2.2538099 |
| Sum | 1868989 |
| Variance | 180.72724 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 10 | 9826 | 8.7% |
| 20 | 6566 | 5.8% |
| 15 | 6558 | 5.8% |
| 12 | 6263 | 5.6% |
| 11 | 6147 | 5.5% |
| 2 | 4997 | 4.4% |
| 4 | 4668 | 4.1% |
| 8 | 4660 | 4.1% |
| 16 | 4577 | 4.1% |
| 5 | 4560 | 4.0% |
| Other values (92) | 53810 |
| Value | Count | Frequency (%) |
| 2 | 4997 | |
| 3 | 2710 | 2.4% |
| 4 | 4668 | |
| 5 | 4560 | |
| 6 | 3396 | 3.0% |
| 7 | 4202 | |
| 8 | 4660 | |
| 9 | 3201 | 2.8% |
| 10 | 9826 | |
| 11 | 6147 |
| Value | Count | Frequency (%) |
| 105 | 134 | |
| 104 | 12 | < 0.1% |
| 103 | 49 | < 0.1% |
| 102 | 10 | < 0.1% |
| 100 | 42 | < 0.1% |
| 99 | 5 | < 0.1% |
| 98 | 3 | < 0.1% |
| 97 | 2 | < 0.1% |
| 96 | 8 | < 0.1% |
| 95 | 22 | < 0.1% |
product_width_cm
Real number (ℝ)
| Distinct | 95 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 18 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 22.996546 |
| Minimum | 6 |
|---|---|
| Maximum | 118 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.7 MiB |
Quantile statistics
| Minimum | 6 |
|---|---|
| 5-th percentile | 11 |
| Q1 | 15 |
| median | 20 |
| Q3 | 30 |
| 95-th percentile | 45 |
| Maximum | 118 |
| Range | 112 |
| Interquartile range (IQR) | 15 |
Descriptive statistics
| Standard deviation | 11.707268 |
|---|---|
| Coefficient of variation (CV) | 0.50908811 |
| Kurtosis | 4.6869659 |
| Mean | 22.996546 |
| Median Absolute Deviation (MAD) | 6 |
| Skewness | 1.7266011 |
| Sum | 2590147 |
| Variance | 137.06013 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 20 | 12095 | 10.7% |
| 11 | 10667 | 9.5% |
| 15 | 8951 | 7.9% |
| 16 | 8461 | 7.5% |
| 30 | 7626 | 6.8% |
| 12 | 5463 | 4.8% |
| 13 | 5264 | 4.7% |
| 14 | 4607 | 4.1% |
| 18 | 4064 | 3.6% |
| 40 | 3895 | 3.5% |
| Other values (85) | 41539 |
| Value | Count | Frequency (%) |
| 6 | 2 | < 0.1% |
| 7 | 5 | < 0.1% |
| 8 | 28 | < 0.1% |
| 9 | 50 | < 0.1% |
| 10 | 82 | 0.1% |
| 11 | 10667 | |
| 12 | 5463 | |
| 13 | 5264 | |
| 14 | 4607 | |
| 15 | 8951 |
| Value | Count | Frequency (%) |
| 118 | 8 | < 0.1% |
| 105 | 14 | < 0.1% |
| 104 | 1 | < 0.1% |
| 103 | 1 | < 0.1% |
| 102 | 2 | < 0.1% |
| 101 | 2 | < 0.1% |
| 100 | 42 | |
| 98 | 1 | < 0.1% |
| 97 | 1 | < 0.1% |
| 95 | 2 | < 0.1% |
order_id
Categorical
HIGH CARDINALITY  UNIFORM 
| Distinct | 98666 |
|---|---|
| Distinct (%) | 87.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.7 MiB |
| 8272b63d03f5f79c56e9e4120aec44ef | 21 |
|---|---|
| ab14fdcfbe524636d65ee38360e22ce8 | 20 |
| 1b15974a0141d54e36626dca3fdc731a | 20 |
| 428a2f660dc84138d969ccd69a0ab6d5 | 15 |
| 9ef13efd6949e4573a18964dd1bbe7f5 | 15 |
| Other values (98661) |
Length
| Max length | 32 |
|---|---|
| Median length | 32 |
| Mean length | 32 |
| Min length | 32 |
Characters and Unicode
| Total characters | 3604800 |
|---|---|
| Distinct characters | 16 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 88863 ? |
|---|---|
| Unique (%) | 78.9% |
Sample
| 1st row | e17e4f88e31525f7deef66779844ddce |
|---|---|
| 2nd row | 5236307716393b7114b53ee991f36956 |
| 3rd row | 01f66e58769f84129811d43eefd187fb |
| 4th row | 143d00a4f2dde4e0364ee1821577adb3 |
| 5th row | 86cafb8794cb99a9b1b77fc8e48fbbbb |
Common Values
| Value | Count | Frequency (%) |
| 8272b63d03f5f79c56e9e4120aec44ef | 21 | < 0.1% |
| ab14fdcfbe524636d65ee38360e22ce8 | 20 | < 0.1% |
| 1b15974a0141d54e36626dca3fdc731a | 20 | < 0.1% |
| 428a2f660dc84138d969ccd69a0ab6d5 | 15 | < 0.1% |
| 9ef13efd6949e4573a18964dd1bbe7f5 | 15 | < 0.1% |
| 9bdc4d4c71aa1de4606060929dee888c | 14 | < 0.1% |
| 73c8ab38f07dc94389065f7eba4f297a | 14 | < 0.1% |
| 37ee401157a3a0b28c9c6d0ed8c3b24b | 13 | < 0.1% |
| af822dacd6f5cff7376413c03a388bb7 | 12 | < 0.1% |
| c05d6a79e55da72ca780ce90364abed9 | 12 | < 0.1% |
| Other values (98656) | 112494 |
Length
| Value | Count | Frequency (%) |
| 8272b63d03f5f79c56e9e4120aec44ef | 21 | < 0.1% |
| 1b15974a0141d54e36626dca3fdc731a | 20 | < 0.1% |
| ab14fdcfbe524636d65ee38360e22ce8 | 20 | < 0.1% |
| 428a2f660dc84138d969ccd69a0ab6d5 | 15 | < 0.1% |
| 9ef13efd6949e4573a18964dd1bbe7f5 | 15 | < 0.1% |
| 9bdc4d4c71aa1de4606060929dee888c | 14 | < 0.1% |
| 73c8ab38f07dc94389065f7eba4f297a | 14 | < 0.1% |
| 37ee401157a3a0b28c9c6d0ed8c3b24b | 13 | < 0.1% |
| 2c2a19b5703863c908512d135aa6accc | 12 | < 0.1% |
| 637617b3ffe9e2f7a2411243829226d0 | 12 | < 0.1% |
| Other values (98656) | 112494 |
Most occurring characters
| Value | Count | Frequency (%) |
| 4 | 226438 | 6.3% |
| 6 | 225940 | 6.3% |
| b | 225897 | 6.3% |
| e | 225872 | 6.3% |
| 7 | 225739 | 6.3% |
| 3 | 225711 | 6.3% |
| a | 225498 | 6.3% |
| 2 | 225476 | 6.3% |
| 8 | 225358 | 6.3% |
| 1 | 225287 | 6.2% |
| Other values (6) | 1347584 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 2252967 | |
| Lowercase Letter | 1351833 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 4 | 226438 | |
| 6 | 225940 | |
| 7 | 225739 | |
| 3 | 225711 | |
| 2 | 225476 | |
| 8 | 225358 | |
| 1 | 225287 | |
| 9 | 224719 | |
| 0 | 224470 | |
| 5 | 223829 |
Lowercase Letter
| Value | Count | Frequency (%) |
| b | 225897 | |
| e | 225872 | |
| a | 225498 | |
| c | 225204 | |
| f | 225069 | |
| d | 224293 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 2252967 | |
| Latin | 1351833 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 4 | 226438 | |
| 6 | 225940 | |
| 7 | 225739 | |
| 3 | 225711 | |
| 2 | 225476 | |
| 8 | 225358 | |
| 1 | 225287 | |
| 9 | 224719 | |
| 0 | 224470 | |
| 5 | 223829 |
Latin
| Value | Count | Frequency (%) |
| b | 225897 | |
| e | 225872 | |
| a | 225498 | |
| c | 225204 | |
| f | 225069 | |
| d | 224293 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 3604800 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 4 | 226438 | 6.3% |
| 6 | 225940 | 6.3% |
| b | 225897 | 6.3% |
| e | 225872 | 6.3% |
| 7 | 225739 | 6.3% |
| 3 | 225711 | 6.3% |
| a | 225498 | 6.3% |
| 2 | 225476 | 6.3% |
| 8 | 225358 | 6.3% |
| 1 | 225287 | 6.2% |
| Other values (6) | 1347584 |
order_item_id
Real number (ℝ)
| Distinct | 21 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.197834 |
| Minimum | 1 |
|---|---|
| Maximum | 21 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.7 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 1 |
| 95-th percentile | 2 |
| Maximum | 21 |
| Range | 20 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.70512403 |
|---|---|
| Coefficient of variation (CV) | 0.5886659 |
| Kurtosis | 103.85736 |
| Mean | 1.197834 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 7.5803557 |
| Sum | 134936 |
| Variance | 0.4971999 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 98666 | |
| 2 | 9803 | 8.7% |
| 3 | 2287 | 2.0% |
| 4 | 965 | 0.9% |
| 5 | 460 | 0.4% |
| 6 | 256 | 0.2% |
| 7 | 58 | 0.1% |
| 8 | 36 | < 0.1% |
| 9 | 28 | < 0.1% |
| 10 | 25 | < 0.1% |
| Other values (11) | 66 | 0.1% |
| Value | Count | Frequency (%) |
| 1 | 98666 | |
| 2 | 9803 | 8.7% |
| 3 | 2287 | 2.0% |
| 4 | 965 | 0.9% |
| 5 | 460 | 0.4% |
| 6 | 256 | 0.2% |
| 7 | 58 | 0.1% |
| 8 | 36 | < 0.1% |
| 9 | 28 | < 0.1% |
| 10 | 25 | < 0.1% |
| Value | Count | Frequency (%) |
| 21 | 1 | < 0.1% |
| 20 | 3 | < 0.1% |
| 19 | 3 | < 0.1% |
| 18 | 3 | < 0.1% |
| 17 | 3 | < 0.1% |
| 16 | 3 | < 0.1% |
| 15 | 5 | < 0.1% |
| 14 | 7 | |
| 13 | 8 | |
| 12 | 13 |
seller_id
Categorical
| Distinct | 3095 |
|---|---|
| Distinct (%) | 2.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.7 MiB |
| 6560211a19b47992c3666cc44a7e94c0 | 2033 |
|---|---|
| 4a3ca9315b744ce9f8e9374361493884 | 1987 |
| 1f50f920176fa81dab994f9023523100 | 1931 |
| cc419e0650a3c5ba77189a1882b7556a | 1775 |
| da8622b14eb17ae2831f4ac5b9dab84a | 1551 |
| Other values (3090) |
Length
| Max length | 32 |
|---|---|
| Median length | 32 |
| Mean length | 32 |
| Min length | 32 |
Characters and Unicode
| Total characters | 3604800 |
|---|---|
| Distinct characters | 16 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 509 ? |
|---|---|
| Unique (%) | 0.5% |
Sample
| 1st row | 5670f4db5b62c43d542e1b2d56b0cf7c |
|---|---|
| 2nd row | b561927807645834b59ef0d16ba55a24 |
| 3rd row | 7b07b3c7487f0ea825fc6df75abd658b |
| 4th row | c510bc1718f0f2961eaa42a23330681a |
| 5th row | 0be8ff43f22e456b4e0371b2245e4d01 |
Common Values
| Value | Count | Frequency (%) |
| 6560211a19b47992c3666cc44a7e94c0 | 2033 | 1.8% |
| 4a3ca9315b744ce9f8e9374361493884 | 1987 | 1.8% |
| 1f50f920176fa81dab994f9023523100 | 1931 | 1.7% |
| cc419e0650a3c5ba77189a1882b7556a | 1775 | 1.6% |
| da8622b14eb17ae2831f4ac5b9dab84a | 1551 | 1.4% |
| 955fee9216a65b617aa5c0531780ce60 | 1499 | 1.3% |
| 1025f0e2d44d7041d6cf58b6550e0bfa | 1428 | 1.3% |
| 7c67e1448b00f6e969d365cea6b010ab | 1364 | 1.2% |
| ea8482cd71df3c1969d7b9473ff13abc | 1203 | 1.1% |
| 7a67c85e85bb2ce8582c35f2203ad736 | 1171 | 1.0% |
| Other values (3085) | 96708 |
Length
| Value | Count | Frequency (%) |
| 6560211a19b47992c3666cc44a7e94c0 | 2033 | 1.8% |
| 4a3ca9315b744ce9f8e9374361493884 | 1987 | 1.8% |
| 1f50f920176fa81dab994f9023523100 | 1931 | 1.7% |
| cc419e0650a3c5ba77189a1882b7556a | 1775 | 1.6% |
| da8622b14eb17ae2831f4ac5b9dab84a | 1551 | 1.4% |
| 955fee9216a65b617aa5c0531780ce60 | 1499 | 1.3% |
| 1025f0e2d44d7041d6cf58b6550e0bfa | 1428 | 1.3% |
| 7c67e1448b00f6e969d365cea6b010ab | 1364 | 1.2% |
| ea8482cd71df3c1969d7b9473ff13abc | 1203 | 1.1% |
| 7a67c85e85bb2ce8582c35f2203ad736 | 1171 | 1.0% |
| Other values (3085) | 96708 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 244290 | 6.8% |
| c | 237797 | 6.6% |
| 4 | 236139 | 6.6% |
| 6 | 232243 | 6.4% |
| 0 | 231143 | 6.4% |
| a | 229817 | 6.4% |
| b | 229114 | 6.4% |
| 3 | 228981 | 6.4% |
| 9 | 223671 | 6.2% |
| 2 | 222808 | 6.2% |
| Other values (6) | 1288797 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 2279606 | |
| Lowercase Letter | 1325194 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 244290 | |
| 4 | 236139 | |
| 6 | 232243 | |
| 0 | 231143 | |
| 3 | 228981 | |
| 9 | 223671 | |
| 2 | 222808 | |
| 5 | 220264 | |
| 8 | 220219 | |
| 7 | 219848 |
Lowercase Letter
| Value | Count | Frequency (%) |
| c | 237797 | |
| a | 229817 | |
| b | 229114 | |
| e | 212401 | |
| f | 209103 | |
| d | 206962 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 2279606 | |
| Latin | 1325194 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 244290 | |
| 4 | 236139 | |
| 6 | 232243 | |
| 0 | 231143 | |
| 3 | 228981 | |
| 9 | 223671 | |
| 2 | 222808 | |
| 5 | 220264 | |
| 8 | 220219 | |
| 7 | 219848 |
Latin
| Value | Count | Frequency (%) |
| c | 237797 | |
| a | 229817 | |
| b | 229114 | |
| e | 212401 | |
| f | 209103 | |
| d | 206962 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 3604800 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 244290 | 6.8% |
| c | 237797 | 6.6% |
| 4 | 236139 | 6.6% |
| 6 | 232243 | 6.4% |
| 0 | 231143 | 6.4% |
| a | 229817 | 6.4% |
| b | 229114 | 6.4% |
| 3 | 228981 | 6.4% |
| 9 | 223671 | 6.2% |
| 2 | 222808 | 6.2% |
| Other values (6) | 1288797 |
shipping_limit_date
Categorical
HIGH CARDINALITY  UNIFORM 
| Distinct | 93318 |
|---|---|
| Distinct (%) | 82.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.7 MiB |
| 2018-03-01 02:50:48 | 21 |
|---|---|
| 2017-07-21 18:25:23 | 21 |
| 2017-08-30 14:30:23 | 20 |
| 2017-12-21 02:30:41 | 15 |
| 2017-11-30 10:30:51 | 15 |
| Other values (93313) |
Length
| Max length | 19 |
|---|---|
| Median length | 19 |
| Mean length | 19 |
| Min length | 19 |
Characters and Unicode
| Total characters | 2140350 |
|---|---|
| Distinct characters | 13 |
| Distinct categories | 4 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 79836 ? |
|---|---|
| Unique (%) | 70.9% |
Sample
| 1st row | 2018-04-30 17:33:54 |
|---|---|
| 2nd row | 2018-02-06 19:11:15 |
| 3rd row | 2018-07-11 21:30:20 |
| 4th row | 2018-08-07 09:10:13 |
| 5th row | 2018-04-17 01:30:23 |
Common Values
| Value | Count | Frequency (%) |
| 2018-03-01 02:50:48 | 21 | < 0.1% |
| 2017-07-21 18:25:23 | 21 | < 0.1% |
| 2017-08-30 14:30:23 | 20 | < 0.1% |
| 2017-12-21 02:30:41 | 15 | < 0.1% |
| 2017-11-30 10:30:51 | 15 | < 0.1% |
| 2017-02-03 21:44:49 | 15 | < 0.1% |
| 2018-02-28 11:48:12 | 14 | < 0.1% |
| 2018-06-13 17:30:35 | 13 | < 0.1% |
| 2018-04-25 22:11:43 | 13 | < 0.1% |
| 2018-04-19 02:30:52 | 13 | < 0.1% |
| Other values (93308) | 112490 |
Length
| Value | Count | Frequency (%) |
| 2017-11-30 | 1647 | 0.7% |
| 2017-12-07 | 752 | 0.3% |
| 2018-04-19 | 709 | 0.3% |
| 2018-05-10 | 673 | 0.3% |
| 2018-01-18 | 661 | 0.3% |
| 2018-03-08 | 653 | 0.3% |
| 2018-08-07 | 653 | 0.3% |
| 2018-02-22 | 651 | 0.3% |
| 2018-03-01 | 644 | 0.3% |
| 2018-03-22 | 632 | 0.3% |
| Other values (40675) | 217625 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 361652 | |
| 1 | 346105 | |
| 2 | 275987 | |
| - | 225300 | |
| : | 225300 | |
| 8 | 113614 | 5.3% |
| 112650 | 5.3% | |
| 3 | 108862 | 5.1% |
| 5 | 106657 | 5.0% |
| 7 | 96681 | 4.5% |
| Other values (3) | 167542 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 1577100 | |
| Dash Punctuation | 225300 | 10.5% |
| Other Punctuation | 225300 | 10.5% |
| Space Separator | 112650 | 5.3% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 361652 | |
| 1 | 346105 | |
| 2 | 275987 | |
| 8 | 113614 | 7.2% |
| 3 | 108862 | 6.9% |
| 5 | 106657 | 6.8% |
| 7 | 96681 | 6.1% |
| 4 | 75623 | 4.8% |
| 6 | 47204 | 3.0% |
| 9 | 44715 | 2.8% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 225300 |
Other Punctuation
| Value | Count | Frequency (%) |
| : | 225300 |
Space Separator
| Value | Count | Frequency (%) |
| 112650 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 2140350 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 361652 | |
| 1 | 346105 | |
| 2 | 275987 | |
| - | 225300 | |
| : | 225300 | |
| 8 | 113614 | 5.3% |
| 112650 | 5.3% | |
| 3 | 108862 | 5.1% |
| 5 | 106657 | 5.0% |
| 7 | 96681 | 4.5% |
| Other values (3) | 167542 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 2140350 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 361652 | |
| 1 | 346105 | |
| 2 | 275987 | |
| - | 225300 | |
| : | 225300 | |
| 8 | 113614 | 5.3% |
| 112650 | 5.3% | |
| 3 | 108862 | 5.1% |
| 5 | 106657 | 5.0% |
| 7 | 96681 | 4.5% |
| Other values (3) | 167542 |
price
Real number (ℝ)
| Distinct | 5968 |
|---|---|
| Distinct (%) | 5.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 120.65374 |
| Minimum | 0.85 |
|---|---|
| Maximum | 6735 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.7 MiB |
Quantile statistics
| Minimum | 0.85 |
|---|---|
| 5-th percentile | 17 |
| Q1 | 39.9 |
| median | 74.99 |
| Q3 | 134.9 |
| 95-th percentile | 349.9 |
| Maximum | 6735 |
| Range | 6734.15 |
| Interquartile range (IQR) | 95 |
Descriptive statistics
| Standard deviation | 183.63393 |
|---|---|
| Coefficient of variation (CV) | 1.5219912 |
| Kurtosis | 120.8283 |
| Mean | 120.65374 |
| Median Absolute Deviation (MAD) | 42.09 |
| Skewness | 7.9232083 |
| Sum | 13591644 |
| Variance | 33721.42 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 59.9 | 2481 | 2.2% |
| 69.9 | 1987 | 1.8% |
| 49.9 | 1953 | 1.7% |
| 89.9 | 1548 | 1.4% |
| 99.9 | 1432 | 1.3% |
| 39.9 | 1339 | 1.2% |
| 29.9 | 1318 | 1.2% |
| 79.9 | 1214 | 1.1% |
| 19.9 | 1201 | 1.1% |
| 29.99 | 1176 | 1.0% |
| Other values (5958) | 97001 |
| Value | Count | Frequency (%) |
| 0.85 | 3 | < 0.1% |
| 1.2 | 20 | |
| 2.2 | 1 | < 0.1% |
| 2.29 | 1 | < 0.1% |
| 2.9 | 1 | < 0.1% |
| 2.99 | 1 | < 0.1% |
| 3 | 2 | < 0.1% |
| 3.06 | 3 | < 0.1% |
| 3.49 | 3 | < 0.1% |
| 3.5 | 7 | < 0.1% |
| Value | Count | Frequency (%) |
| 6735 | 1 | |
| 6729 | 1 | |
| 6499 | 1 | |
| 4799 | 1 | |
| 4690 | 1 | |
| 4590 | 1 | |
| 4399.87 | 1 | |
| 4099.99 | 1 | |
| 4059 | 1 | |
| 3999.9 | 1 |
freight_value
Real number (ℝ)
| Distinct | 6999 |
|---|---|
| Distinct (%) | 6.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 19.99032 |
| Minimum | 0 |
|---|---|
| Maximum | 409.68 |
| Zeros | 383 |
| Zeros (%) | 0.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.7 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 7.78 |
| Q1 | 13.08 |
| median | 16.26 |
| Q3 | 21.15 |
| 95-th percentile | 45.12 |
| Maximum | 409.68 |
| Range | 409.68 |
| Interquartile range (IQR) | 8.07 |
Descriptive statistics
| Standard deviation | 15.806405 |
|---|---|
| Coefficient of variation (CV) | 0.79070297 |
| Kurtosis | 59.788253 |
| Mean | 19.99032 |
| Median Absolute Deviation (MAD) | 3.61 |
| Skewness | 5.6398696 |
| Sum | 2251909.5 |
| Variance | 249.84245 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 15.1 | 3707 | 3.3% |
| 7.78 | 2262 | 2.0% |
| 14.1 | 1875 | 1.7% |
| 11.85 | 1846 | 1.6% |
| 18.23 | 1575 | 1.4% |
| 7.39 | 1521 | 1.4% |
| 16.11 | 1152 | 1.0% |
| 15.23 | 1010 | 0.9% |
| 8.72 | 921 | 0.8% |
| 16.79 | 873 | 0.8% |
| Other values (6989) | 95908 |
| Value | Count | Frequency (%) |
| 0 | 383 | |
| 0.01 | 4 | < 0.1% |
| 0.02 | 3 | < 0.1% |
| 0.03 | 14 | < 0.1% |
| 0.04 | 4 | < 0.1% |
| 0.05 | 4 | < 0.1% |
| 0.06 | 11 | < 0.1% |
| 0.07 | 1 | < 0.1% |
| 0.08 | 12 | < 0.1% |
| 0.09 | 6 | < 0.1% |
| Value | Count | Frequency (%) |
| 409.68 | 1 | |
| 375.28 | 2 | |
| 339.59 | 1 | |
| 338.3 | 1 | |
| 322.1 | 1 | |
| 321.88 | 1 | |
| 321.46 | 1 | |
| 317.47 | 1 | |
| 314.4 | 1 | |
| 314.02 | 1 |
| product_name_lenght | product_description_lenght | product_photos_qty | product_weight_g | product_length_cm | product_height_cm | product_width_cm | order_item_id | price | freight_value | product_category_name | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| product_name_lenght | 1.000 | 0.074 | 0.164 | 0.076 | 0.062 | -0.055 | 0.067 | -0.020 | 0.040 | 0.034 | 0.131 |
| product_description_lenght | 0.074 | 1.000 | 0.110 | 0.095 | -0.018 | 0.132 | -0.079 | -0.032 | 0.209 | 0.117 | 0.203 |
| product_photos_qty | 0.164 | 0.110 | 1.000 | 0.006 | 0.007 | -0.080 | -0.012 | -0.066 | 0.028 | 0.010 | 0.152 |
| product_weight_g | 0.076 | 0.095 | 0.006 | 1.000 | 0.618 | 0.533 | 0.620 | -0.000 | 0.514 | 0.447 | 0.199 |
| product_length_cm | 0.062 | -0.018 | 0.007 | 0.618 | 1.000 | 0.250 | 0.631 | 0.006 | 0.267 | 0.284 | 0.259 |
| product_height_cm | -0.055 | 0.132 | -0.080 | 0.533 | 0.250 | 1.000 | 0.342 | 0.018 | 0.327 | 0.282 | 0.278 |
| product_width_cm | 0.067 | -0.079 | -0.012 | 0.620 | 0.631 | 0.342 | 1.000 | -0.005 | 0.271 | 0.274 | 0.295 |
| order_item_id | -0.020 | -0.032 | -0.066 | -0.000 | 0.006 | 0.018 | -0.005 | 1.000 | -0.117 | -0.055 | 0.029 |
| price | 0.040 | 0.209 | 0.028 | 0.514 | 0.267 | 0.327 | 0.271 | -0.117 | 1.000 | 0.434 | 0.114 |
| freight_value | 0.034 | 0.117 | 0.010 | 0.447 | 0.284 | 0.282 | 0.274 | -0.055 | 0.434 | 1.000 | 0.093 |
| product_category_name | 0.131 | 0.203 | 0.152 | 0.199 | 0.259 | 0.278 | 0.295 | 0.029 | 0.114 | 0.093 | 1.000 |
| product_id | product_category_name | product_name_lenght | product_description_lenght | product_photos_qty | product_weight_g | product_length_cm | product_height_cm | product_width_cm | order_id | order_item_id | seller_id | shipping_limit_date | price | freight_value | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 1e9e8ef04dbcff4541ed26657ea517e5 | perfumaria | 40.0 | 287.0 | 1.0 | 225.0 | 16.0 | 10.0 | 14.0 | e17e4f88e31525f7deef66779844ddce | 1 | 5670f4db5b62c43d542e1b2d56b0cf7c | 2018-04-30 17:33:54 | 10.91 | 7.39 |
| 1 | 3aa071139cb16b67ca9e5dea641aaa2f | artes | 44.0 | 276.0 | 1.0 | 1000.0 | 30.0 | 18.0 | 20.0 | 5236307716393b7114b53ee991f36956 | 1 | b561927807645834b59ef0d16ba55a24 | 2018-02-06 19:11:15 | 248.00 | 17.99 |
| 2 | 96bd76ec8810374ed1b65e291975717f | esporte_lazer | 46.0 | 250.0 | 1.0 | 154.0 | 18.0 | 9.0 | 15.0 | 01f66e58769f84129811d43eefd187fb | 1 | 7b07b3c7487f0ea825fc6df75abd658b | 2018-07-11 21:30:20 | 79.80 | 7.82 |
| 3 | cef67bcfe19066a932b7673e239eb23d | bebes | 27.0 | 261.0 | 1.0 | 371.0 | 26.0 | 4.0 | 26.0 | 143d00a4f2dde4e0364ee1821577adb3 | 1 | c510bc1718f0f2961eaa42a23330681a | 2018-08-07 09:10:13 | 112.30 | 9.54 |
| 4 | 9dc1a7de274444849c219cff195d0b71 | utilidades_domesticas | 37.0 | 402.0 | 4.0 | 625.0 | 20.0 | 17.0 | 13.0 | 86cafb8794cb99a9b1b77fc8e48fbbbb | 1 | 0be8ff43f22e456b4e0371b2245e4d01 | 2018-04-17 01:30:23 | 37.90 | 8.29 |
| 5 | 41d3672d4792049fa1779bb35283ed13 | instrumentos_musicais | 60.0 | 745.0 | 1.0 | 200.0 | 38.0 | 5.0 | 11.0 | c214058828b43a44f352b56ff2d5c0a5 | 1 | ce248b21cb2adc36282ede306b7660e5 | 2018-03-19 15:48:29 | 45.87 | 19.95 |
| 6 | 732bd381ad09e530fe0a5f457d81becb | cool_stuff | 56.0 | 1272.0 | 4.0 | 18350.0 | 70.0 | 24.0 | 44.0 | 9632facd8bd95315d63a23bf616d85b0 | 1 | 8b8cfc8305aa441e4239358c9f6f2485 | 2018-01-18 12:39:24 | 958.00 | 27.76 |
| 7 | 732bd381ad09e530fe0a5f457d81becb | cool_stuff | 56.0 | 1272.0 | 4.0 | 18350.0 | 70.0 | 24.0 | 44.0 | c6343db6c1801f9c3301166f02931116 | 1 | 8b8cfc8305aa441e4239358c9f6f2485 | 2017-12-11 11:30:51 | 968.00 | 44.30 |
| 8 | 2548af3e6e77a690cf3eb6368e9ab61e | moveis_decoracao | 56.0 | 184.0 | 2.0 | 900.0 | 40.0 | 8.0 | 40.0 | 6ecf7023e8dd4ec8b08746c35b9fcb60 | 3 | 95f83f51203c626648c875dd41874c7f | 2017-11-30 16:31:00 | 9.99 | 16.02 |
| 9 | 2548af3e6e77a690cf3eb6368e9ab61e | moveis_decoracao | 56.0 | 184.0 | 2.0 | 900.0 | 40.0 | 8.0 | 40.0 | 6ecf7023e8dd4ec8b08746c35b9fcb60 | 4 | 95f83f51203c626648c875dd41874c7f | 2017-11-30 16:31:00 | 9.99 | 16.02 |
| product_id | product_category_name | product_name_lenght | product_description_lenght | product_photos_qty | product_weight_g | product_length_cm | product_height_cm | product_width_cm | order_id | order_item_id | seller_id | shipping_limit_date | price | freight_value | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 112640 | 9a7c6041fa9592d9d9ef6cfe62a71f8c | cama_mesa_banho | 50.0 | 799.0 | 1.0 | 1400.0 | 27.0 | 7.0 | 27.0 | 7c8a032bb75e0e4d524b14ba147d4ba5 | 1 | 439a47cc365d6e3bd526812ea9de3c29 | 2017-08-25 15:50:13 | 127.50 | 17.14 |
| 112641 | 9a7c6041fa9592d9d9ef6cfe62a71f8c | cama_mesa_banho | 50.0 | 799.0 | 1.0 | 1400.0 | 27.0 | 7.0 | 27.0 | fc957026f2482ab3bddf91ebc9d0dfc5 | 1 | e4ebd3f87bf70440014f07ddda7fbe03 | 2018-01-16 21:31:29 | 127.00 | 12.39 |
| 112642 | 83808703fc0706a22e264b9d75f04a2e | informatica_acessorios | 60.0 | 156.0 | 2.0 | 700.0 | 31.0 | 13.0 | 20.0 | 420937423f0cb3d3fe689330b5d385a9 | 1 | 4324dd16853115efb0fd9d0d131ba6f4 | 2017-10-26 02:49:13 | 39.71 | 16.11 |
| 112643 | 83808703fc0706a22e264b9d75f04a2e | informatica_acessorios | 60.0 | 156.0 | 2.0 | 700.0 | 31.0 | 13.0 | 20.0 | 420937423f0cb3d3fe689330b5d385a9 | 2 | 4324dd16853115efb0fd9d0d131ba6f4 | 2017-10-26 02:49:13 | 39.71 | 16.11 |
| 112644 | 83808703fc0706a22e264b9d75f04a2e | informatica_acessorios | 60.0 | 156.0 | 2.0 | 700.0 | 31.0 | 13.0 | 20.0 | 59e88b7d3675e89aceaf86f372d3bc9a | 1 | 4324dd16853115efb0fd9d0d131ba6f4 | 2018-01-10 03:32:09 | 29.90 | 16.11 |
| 112645 | 83808703fc0706a22e264b9d75f04a2e | informatica_acessorios | 60.0 | 156.0 | 2.0 | 700.0 | 31.0 | 13.0 | 20.0 | 59e88b7d3675e89aceaf86f372d3bc9a | 2 | 4324dd16853115efb0fd9d0d131ba6f4 | 2018-01-10 03:32:09 | 29.90 | 16.11 |
| 112646 | 83808703fc0706a22e264b9d75f04a2e | informatica_acessorios | 60.0 | 156.0 | 2.0 | 700.0 | 31.0 | 13.0 | 20.0 | 6e4465d771f02e4fe335225de3c6c043 | 1 | 4324dd16853115efb0fd9d0d131ba6f4 | 2018-03-14 02:30:48 | 29.90 | 23.28 |
| 112647 | 83808703fc0706a22e264b9d75f04a2e | informatica_acessorios | 60.0 | 156.0 | 2.0 | 700.0 | 31.0 | 13.0 | 20.0 | 6e4465d771f02e4fe335225de3c6c043 | 2 | 4324dd16853115efb0fd9d0d131ba6f4 | 2018-03-14 02:30:48 | 29.90 | 23.28 |
| 112648 | 83808703fc0706a22e264b9d75f04a2e | informatica_acessorios | 60.0 | 156.0 | 2.0 | 700.0 | 31.0 | 13.0 | 20.0 | 6e4465d771f02e4fe335225de3c6c043 | 3 | 4324dd16853115efb0fd9d0d131ba6f4 | 2018-03-14 02:30:48 | 29.90 | 23.28 |
| 112649 | 106392145fca363410d287a815be6de4 | cama_mesa_banho | 58.0 | 309.0 | 1.0 | 2083.0 | 12.0 | 2.0 | 7.0 | f3a47ba087f05d39a74ed1b653f0be1b | 1 | 4a3ca9315b744ce9f8e9374361493884 | 2018-07-02 08:30:34 | 107.50 | 27.05 |